package com.example.zyh.mapper;


import com.example.zyh.pojo.Xzl;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface XzlMapper {
    @Select("select * from xzl")
    public List<Xzl> select();
    @Insert("INSERT INTO xzl (`number`, `area`, `carea`)VALUES(#{number},#{area},#{carea})")
    public void addXzl(Xzl xzl);
    @Delete("delete from xzl where id=#{id}")
    public void deleteXzl(int id);
    @Update("UPDATE xzl SET `number` = #{number} , `area` = #{area}, `carea` =#{carea} WHERE `id` = #{id}")
    public void updateXzl(Xzl xzl);
}
